It's unrealistic to expect police to be unarmed and go round hugging people when they would likely be quickly shot dead. So you are always going to have aggressive confrontations as you need to portray strength and intimidate people otherwise you might die.
I think we may be talking about two very different things. Community policing means an officer works a specific area which allows them to become familiar with the locals and build rapport. It does NOT mean they're unarmed or unable to carry out any of the functions necessary to do their job.
"Community policing is a philosophy of full service personalized policing, where the same officer patrols and works in the same area on a permanent basis, from a decentralized place, working in a proactive partnership with citizens to identify and solve problems."
"Community policing, recognizing that police rarely can solve public safety problems alone, encourages interactive partnerships with relevant stakeholders. The range of potential partners is large, and these partnerships can be used to accomplish the two interrelated goals of developing solutions to problems through collaborative problem solving and improving public trust. The public should play a role in prioritizing and addressing public safety problems."
"Community policing emphasizes proactive problem solving in a systematic and routine fashion. Rather than responding to crime only after it occurs, community policing encourages agencies to proactively develop solutions to the immediate underlying conditions contributing to public safety problems. Problem solving must be infused into all police operations and guide decision making efforts. Agencies are encouraged to think innovatively about their responses and view making arrests as only one of a wide array of potential responses. A major conceptual vehicle for helping officers to think about problem solving in a structured and disciplined way is the SARA (scanning, analysis, response, and assessment) problem-solving model."